package com.yunupmall.mapper.commoditymapper;


import com.yunupmall.entity.admin.commoditypojo.PayConcetion;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.util.List;

@Mapper
@Repository
public interface PayconcectionMapper {
    @Select("select * from pay_concection limit #{thispage},#{pageSize}")
    List<PayConcetion> getAllData(@Param("thispage") Integer thispage, @Param("pageSize") Integer pageSize);

    @Select("select count(*) as counts from pay_concection")
    int getCounts();

    @Insert("insert into pay_concection(p_name,p_affaic,p_targer,p_time)values(#{name},#{affaic},#{target},#{time})")
    int addData(@Param("name") String patName, @Param("affaic") String text, @Param("time") String time, @Param("target") String patTatgerName);
}
